Rolling budget and forecast1[1]

Reviews

Shared by:

Anonymous

Tags

Budget

Stats

views:: 446
downloads:: 101
rating:: not rated
reviews:: 0
posted:: 10/11/2007
language:: UNKNOWN
pages:: 0

Public Domain

Rolling Budget and Forecast Model Key Numbers in black represent budget numbers or actuals for the current or prior year. Numbers in blue represent forecast numbers for the current year. Italicized numbers in gray cells are calculations that generally should not be altered. Line Item PROFIT AND LOSS Revenue Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Cost of Goods Sold Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) Sales and Marketing Costs Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) Labor Expense Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) General and Administrative Budget Actual Budget variance (Budget – Actual) Prior year Prior year variance (Prior year – Actual) Operating Income Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) BALANCE SHEET Cash Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Inventory Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Accounts Receivable Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Net Fixed Assets Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Accounts Payable Budget January February March Q1 April May June Q2 July August September Q3 October November December Q4 Annual $65,000 $60,000 ($5,000) $55,000 $5,000 $50,000 $47,500 $2,500 $45,000 ($2,500) $8,000 $10,000 ($2,000) $7,000 ($3,000) $35,000 $40,000 ($5,000) $20,000 ($20,000) $10,000 $9,000 $1,000 $5,000 ($4,000) $5,000 ($5,000) ($10,000) ($5,000) $0 $75,000 $70,000 ($5,000) $60,000 $10,000 $55,000 $55,000 $0 $48,000 ($7,000) $3,000 $4,000 ($1,000) $6,000 $2,000 $40,000 $41,000 ($1,000) $25,000 ($16,000) $10,000 $10,000 $0 $6,000 ($4,000) $5,000 ($3,000) ($8,000) ($25,000) $22,000 $85,000 $88,000 $3,000 $70,000 $18,000 $65,000 $63,000 $2,000 $54,000 ($9,000) $4,000 $3,000 $1,000 $5,000 $2,000 $40,000 $42,000 ($2,000) $30,000 ($12,000) $11,000 $12,000 ($1,000) $7,000 ($5,000) $5,000 $2,000 ($3,000) ($27,000) $29,000 $225,000 $218,000 ($7,000) $185,000 $33,000 $170,000 $165,500 $4,500 $147,000 ($18,500) $15,000 $17,000 ($2,000) $18,000 $1,000 $115,000 $123,000 ($8,000) $75,000 ($48,000) $31,000 $31,000 $0 $18,000 ($13,000) $15,000 ($6,000) ($21,000) ($57,000) $51,000 $75,000 $95,000 $20,000 $75,000 $20,000 $55,000 $45,000 $10,000 $49,000 $4,000 $6,000 $5,000 $1,000 $5,000 $0 $40,000 $42,000 ($2,000) $30,000 ($12,000) $11,000 $15,000 ($4,000) $8,000 ($7,000) $10,000 $0 ($10,000) ($15,000) $15,000 $80,000 $65,000 ($15,000) $80,000 ($15,000) $60,000 $55,000 $5,000 $51,000 ($4,000) $7,000 $6,500 $500 $6,000 ($500) $40,000 $43,000 ($3,000) $31,000 ($12,000) $12,000 $13,000 ($1,000) $9,000 ($4,000) $10,000 $5,000 ($5,000) ($15,000) $20,000 $90,000 $88,000 ($2,000) $90,000 ($2,000) $70,000 $63,000 $7,000 $56,000 ($7,000) $8,000 $7,500 $500 $7,000 ($500) $45,000 $45,000 $0 $33,000 ($12,000) $15,000 $14,000 $1,000 $10,000 ($4,000) $10,000 $7,000 ($3,000) ($15,000) $22,000 $245,000 $248,000 $3,000 $245,000 $3,000 $185,000 $163,000 $22,000 $156,000 ($7,000) $21,000 $19,000 $2,000 $18,000 ($1,000) $125,000 $130,000 ($5,000) $94,000 ($36,000) $38,000 $42,000 ($4,000) $27,000 ($15,000) $30,000 $12,000 ($18,000) ($45,000) $57,000 $95,000 $95,000 $0 $90,000 $5,000 $70,000 $70,000 $0 $70,000 $0 $7,500 $7,500 $0 $7,000 ($500) $45,000 $45,000 $0 $34,000 ($11,000) $14,000 $14,000 $0 $10,000 ($4,000) $12,500 $12,500 $0 ($33,000) $45,500 $100,000 $100,000 $0 $95,000 $5,000 $75,000 $75,000 $0 $80,000 $5,000 $8,500 $8,500 $0 $8,000 ($500) $45,000 $45,000 $0 $35,000 ($10,000) $15,000 $15,000 $0 $12,000 ($3,000) $12,500 $12,500 $0 ($25,000) $37,500 $105,000 $105,000 $0 $100,000 $5,000 $80,000 $80,000 $0 $85,000 $5,000 $9,000 $9,000 $0 $8,000 ($1,000) $50,000 $50,000 $0 $36,000 ($14,000) $16,000 $16,000 $0 $13,000 ($3,000) $12,500 $12,500 $0 ($25,000) $37,500 $300,000 $300,000 $0 $285,000 $15,000 $225,000 $225,000 $0 $235,000 $10,000 $25,000 $25,000 $0 $23,000 ($2,000) $140,000 $140,000 $0 $105,000 ($35,000) $45,000 $45,000 $0 $35,000 ($10,000) $37,500 $37,500 $0 ($83,000) $120,500 $120,000 $120,000 $0 $110,000 $10,000 $90,000 $90,000 $0 $95,000 $5,000 $8,000 $8,000 $0 $8,000 $0 $50,000 $50,000 $0 $37,000 ($13,000) $15,000 $15,000 $0 $13,000 ($2,000) $15,000 $15,000 $0 ($30,000) $45,000 $130,000 $130,000 $0 $120,000 $10,000 $100,000 $100,000 $0 $105,000 $5,000 $10,000 $10,000 $0 $9,000 ($1,000) $55,000 $55,000 $0 $38,000 ($17,000) $18,000 $18,000 $0 $14,000 ($4,000) $15,000 $15,000 $0 ($20,000) $35,000 $145,000 $145,000 $0 $130,000 $15,000 $125,000 $125,000 $0 $115,000 ($10,000) $6,500 $6,500 $0 $7,000 $500 $55,000 $55,000 $0 $37,000 ($18,000) $15,000 $15,000 $0 $14,000 ($1,000) $15,000 $15,000 $0 ($20,000) $35,000 $395,000 $395,000 $0 $360,000 $35,000 $315,000 $315,000 $0 $315,000 $0 $24,500 $24,500 $0 $24,000 ($500) $160,000 $160,000 $0 $112,000 ($48,000) $48,000 $48,000 $0 $41,000 ($7,000) $45,000 $45,000 $0 ($70,000) $115,000 $1,165,000 $1,161,000 ($4,000) $1,075,000 $86,000 $895,000 $868,500 $26,500 $853,000 ($15,500) $85,500 $85,500 $0 $83,000 ($2,500) $540,000 $553,000 ($13,000) $386,000 ($167,000) $162,000 $166,000 ($4,000) $121,000 ($45,000) $127,500 $88,500 ($39,000) ($255,000) $343,500 $45,000 $43,000 ($2,000) $125,000 ($82,000) $100,000 $95,000 ($5,000) $80,000 $15,000 $45,000 $47,000 $2,000 $65,000 ($18,000) $250,000 $250,000 $0 $230,000 $20,000 $25,000 $45,000 $42,000 ($3,000) $110,000 ($68,000) $105,000 $100,000 ($5,000) $85,000 $15,000 $48,000 $48,000 $0 $63,000 ($15,000) $245,000 $245,000 $0 $230,000 $15,000 $28,000 $40,000 $41,000 $1,000 $95,000 ($54,000) $110,000 $105,000 ($5,000) $90,000 $15,000 $50,000 $49,000 ($1,000) $61,000 ($12,000) $240,000 $240,000 $0 $231,000 $9,000 $32,000 $40,000 $41,000 $1,000 $95,000 ($54,000) $110,000 $105,000 ($5,000) $90,000 $15,000 $50,000 $49,000 ($1,000) $61,000 ($12,000) $240,000 $240,000 $0 $231,000 $9,000 $32,000 $40,000 $38,000 ($2,000) $85,000 ($47,000) $115,000 $105,000 ($10,000) $90,000 $15,000 $55,000 $51,000 ($4,000) $60,000 ($9,000) $235,000 $235,000 $0 $234,000 $1,000 $34,000 $42,000 $40,000 ($2,000) $75,000 ($35,000) $120,000 $112,000 ($8,000) $100,000 $12,000 $55,000 $53,000 ($2,000) $58,000 ($5,000) $230,000 $230,000 $0 $235,000 ($5,000) $35,000 $45,000 $41,000 ($4,000) $65,000 ($24,000) $125,000 $118,000 ($7,000) $110,000 $8,000 $54,000 $54,000 $0 $55,000 ($1,000) $225,000 $225,000 $0 $235,000 ($10,000) $36,000 $45,000 $41,000 ($4,000) $65,000 ($24,000) $125,000 $118,000 ($7,000) $110,000 $8,000 $54,000 $54,000 $0 $55,000 ($1,000) $225,000 $225,000 $0 $235,000 ($10,000) $36,000 $48,000 $48,000 $0 $60,000 ($12,000) $125,000 $125,000 $0 $115,000 $10,000 $53,000 $53,000 $0 $48,000 $5,000 $300,000 $300,000 $0 $240,000 $60,000 $35,000 $52,000 $52,000 $0 $50,000 $2,000 $125,000 $125,000 $0 $105,000 $20,000 $52,000 $52,000 $0 $45,000 $7,000 $295,000 $295,000 $0 $240,000 $55,000 $34,000 $55,000 $55,000 $0 $40,000 $15,000 $120,000 $120,000 $0 $110,000 $10,000 $51,000 $51,000 $0 $45,000 $6,000 $290,000 $290,000 $0 $242,000 $48,000 $33,000 $55,000 $55,000 $0 $40,000 $15,000 $120,000 $120,000 $0 $110,000 $10,000 $51,000 $51,000 $0 $45,000 $6,000 $290,000 $290,000 $0 $242,000 $48,000 $33,000 $60,000 $60,000 $0 $35,000 $25,000 $115,000 $115,000 $0 $105,000 $10,000 $50,000 $50,000 $0 $47,000 $3,000 $285,000 $285,000 $0 $244,000 $41,000 $32,000 $65,000 $65,000 $0 $30,000 $35,000 $110,000 $110,000 $0 $95,000 $15,000 $50,000 $50,000 $0 $43,000 $7,000 $280,000 $280,000 $0 $245,000 $35,000 $31,000 $70,000 $70,000 $0 $25,000 $45,000 $100,000 $100,000 $0 $90,000 $10,000 $50,000 $50,000 $0 $42,000 $8,000 $275,000 $275,000 $0 $248,000 $27,000 $30,000 $70,000 $70,000 $0 $25,000 $45,000 $100,000 $100,000 $0 $90,000 $10,000 $50,000 $50,000 $0 $42,000 $8,000 $275,000 $275,000 $0 $248,000 $27,000 $30,000 $70,000 $70,000 $0 $25,000 $45,000 $100,000 $100,000 $0 $90,000 $10,000 $50,000 $50,000 $0 $42,000 $8,000 $275,000 $275,000 $0 $248,000 $27,000 $30,000 Rolling Budget and Forecast Model Key Numbers in black represent budget numbers or actuals for the current or prior year. Numbers in blue represent forecast numbers for the current year. Italicized numbers in gray cells are calculations that generally should not be altered. Line Item Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) Long-Term Debt Budget Actual Budget variance (Actual – Budget) Prior year Prior year variance (Actual – Prior year) January $26,000 $1,000 $18,000 $8,000 $125,000 $125,000 $0 $45,000 $80,000 February $30,000 $2,000 $20,000 $10,000 $48,000 $48,000 $0 $45,000 $3,000 March $34,000 $2,000 $24,000 $10,000 $50,000 $49,000 ($1,000) $45,000 $4,000 Q1 $34,000 $2,000 $24,000 $10,000 $50,000 $49,000 ($1,000) $45,000 $4,000 April $35,000 $1,000 $25,000 $10,000 $55,000 $51,000 ($4,000) $65,000 ($14,000) May $35,500 $500 $26,000 $9,500 $55,000 $53,000 ($2,000) $65,000 ($12,000) June $36,500 $500 $26,000 $10,500 $54,000 $54,000 $0 $65,000 ($11,000) Q2 $36,500 $500 $26,000 $10,500 $54,000 $54,000 $0 $65,000 ($11,000) July $35,000 $0 $27,000 $8,000 $53,000 $53,000 $0 $75,000 ($22,000) August $34,000 $0 $28,000 $6,000 $52,000 $52,000 $0 $75,000 ($23,000) September $33,000 $0 $27,000 $6,000 $51,000 $51,000 $0 $75,000 ($24,000) Q3 $33,000 $0 $27,000 $6,000 $51,000 $51,000 $0 $75,000 ($24,000) October $32,000 $0 $28,000 $4,000 $50,000 $50,000 $0 $85,000 ($35,000) November $31,000 $0 $29,000 $2,000 $50,000 $50,000 $0 $85,000 ($35,000) December $30,000 $0 $28,000 $2,000 $50,000 $50,000 $0 $75,000 ($25,000) Q4 $30,000 $0 $28,000 $2,000 $50,000 $50,000 $0 $75,000 ($25,000) Annual $30,000 $0 $28,000 $2,000 $50,000 $50,000 $0 $75,000 ($25,000)